Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 583985 |
| Missing cells | 654318 |
| Missing cells (%) | 5.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 98.0 MiB |
| Average record size in memory | 176.0 B |
Variable types
| Numeric | 11 |
|---|---|
| Categorical | 10 |
| Unsupported | 1 |
TAIL_NUM has a high cardinality: 5446 distinct values | High cardinality |
ORIGIN has a high cardinality: 346 distinct values | High cardinality |
DEST has a high cardinality: 346 distinct values | High cardinality |
OP_CARRIER_AIRLINE_ID is highly overall correlated with OP_UNIQUE_CARRIER and 1 other fields | High correlation |
ORIGIN_AIRPORT_ID is highly overall correlated with ORIGIN_AIRPORT_SEQ_ID | High correlation |
ORIGIN_AIRPORT_SEQ_ID is highly overall correlated with ORIGIN_AIRPORT_ID | High correlation |
DEST_AIRPORT_ID is highly overall correlated with DEST_AIRPORT_SEQ_ID | High correlation |
DEST_AIRPORT_SEQ_ID is highly overall correlated with DEST_AIRPORT_ID | High correlation |
DEP_TIME is highly overall correlated with ARR_TIME and 1 other fields | High correlation |
ARR_TIME is highly overall correlated with DEP_TIME and 2 other fields | High correlation |
OP_UNIQUE_CARRIER is highly overall correlated with OP_CARRIER_AIRLINE_ID and 1 other fields | High correlation |
OP_CARRIER is highly overall correlated with OP_CARRIER_AIRLINE_ID and 1 other fields | High correlation |
DEP_DEL15 is highly overall correlated with ARR_DEL15 | High correlation |
DEP_TIME_BLK is highly overall correlated with DEP_TIME and 1 other fields | High correlation |
ARR_DEL15 is highly overall correlated with DEP_DEL15 and 2 other fields | High correlation |
CANCELLED is highly overall correlated with ARR_TIME and 1 other fields | High correlation |
DIVERTED is highly overall correlated with ARR_DEL15 | High correlation |
CANCELLED is highly imbalanced (81.2%) | Imbalance |
DIVERTED is highly imbalanced (97.7%) | Imbalance |
DEP_TIME has 16352 (2.8%) missing values | Missing |
DEP_DEL15 has 16355 (2.8%) missing values | Missing |
ARR_TIME has 17061 (2.9%) missing values | Missing |
ARR_DEL15 has 18022 (3.1%) missing values | Missing |
Unnamed: 21 has 583985 (100.0%) missing values | Missing |
Unnamed: 21 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2023-03-27 15:39:18.665859 |
|---|---|
| Analysis finished | 2023-03-27 15:40:08.251346 |
| Duration | 49.59 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
DAY_OF_MONTH
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.960088 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 24 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 8.9879417 |
|---|---|
| Coefficient of variation (CV) | 0.56315114 |
| Kurtosis | -1.2118653 |
| Mean | 15.960088 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.013790461 |
| Sum | 9320452 |
| Variance | 80.783096 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 2 | 20384 | 3.5% |
| 11 | 20082 | 3.4% |
| 25 | 20041 | 3.4% |
| 7 | 20015 | 3.4% |
| 18 | 20009 | 3.4% |
| 10 | 19980 | 3.4% |
| 24 | 19963 | 3.4% |
| 31 | 19962 | 3.4% |
| 17 | 19960 | 3.4% |
| 14 | 19941 | 3.4% |
| Other values (21) | 383648 |
| Value | Count | Frequency (%) |
| 1 | 18009 | |
| 2 | 20384 | |
| 3 | 19522 | |
| 4 | 19566 | |
| 5 | 16807 | |
| 6 | 19448 | |
| 7 | 20015 | |
| 8 | 18815 | |
| 9 | 19236 | |
| 10 | 19980 |
| Value | Count | Frequency (%) |
| 31 | 19962 | |
| 30 | 19102 | |
| 29 | 18662 | |
| 28 | 19934 | |
| 27 | 18575 | |
| 26 | 15267 | |
| 25 | 20041 | |
| 24 | 19963 | |
| 23 | 19099 | |
| 22 | 18657 |
DAY_OF_WEEK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.8356259 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.9218991 |
|---|---|
| Coefficient of variation (CV) | 0.50106531 |
| Kurtosis | -1.1030354 |
| Mean | 3.8356259 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.15555045 |
| Sum | 2239948 |
| Variance | 3.6936961 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 99387 | |
| 3 | 96920 | |
| 2 | 92796 | |
| 5 | 79698 | |
| 1 | 79401 | |
| 7 | 73459 | |
| 6 | 62324 |
| Value | Count | Frequency (%) |
| 1 | 79401 | |
| 2 | 92796 | |
| 3 | 96920 | |
| 4 | 99387 | |
| 5 | 79698 | |
| 6 | 62324 | |
| 7 | 73459 |
| Value | Count | Frequency (%) |
| 7 | 73459 | |
| 6 | 62324 | |
| 5 | 79698 | |
| 4 | 99387 | |
| 3 | 96920 | |
| 2 | 92796 | |
| 1 | 79401 |
OP_UNIQUE_CARRIER
Categorical
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| WN | |
|---|---|
| AA | |
| DL | |
| OO | |
| UA | |
| Other values (12) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1167970 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 111312 | |
| AA | 77017 | |
| DL | 73836 | |
| OO | 64926 | |
| UA | 46915 | |
| YX | 25755 | 4.4% |
| MQ | 25699 | 4.4% |
| B6 | 24443 | 4.2% |
| OH | 23169 | 4.0% |
| AS | 20744 | 3.6% |
| Other values (7) | 90169 |
Length
| Value | Count | Frequency (%) |
| wn | 111312 | |
| aa | 77017 | |
| dl | 73836 | |
| oo | 64926 | |
| ua | 46915 | |
| yx | 25755 | 4.4% |
| mq | 25699 | 4.4% |
| b6 | 24443 | 4.2% |
| oh | 23169 | 4.0% |
| as | 20744 | 3.6% |
| Other values (7) | 90169 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 228491 | |
| O | 153021 | |
| N | 126534 | |
| W | 111312 | |
| D | 73836 | 6.3% |
| L | 73836 | 6.3% |
| U | 46915 | 4.0% |
| Y | 44101 | 3.8% |
| E | 33393 | 2.9% |
| V | 31541 | 2.7% |
| Other values (12) | 244990 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1106919 | |
| Decimal Number | 61051 | 5.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 228491 | |
| O | 153021 | |
| N | 126534 | |
| W | 111312 | |
| D | 73836 | 6.7% |
| L | 73836 | 6.7% |
| U | 46915 | 4.2% |
| Y | 44101 | 4.0% |
| E | 33393 | 3.0% |
| V | 31541 | 2.8% |
| Other values (9) | 183939 |
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 29845 | |
| 6 | 24443 | |
| 4 | 6763 | 11.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1106919 | |
| Common | 61051 | 5.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 228491 | |
| O | 153021 | |
| N | 126534 | |
| W | 111312 | |
| D | 73836 | 6.7% |
| L | 73836 | 6.7% |
| U | 46915 | 4.2% |
| Y | 44101 | 4.0% |
| E | 33393 | 3.0% |
| V | 31541 | 2.8% |
| Other values (9) | 183939 |
Common
| Value | Count | Frequency (%) |
| 9 | 29845 | |
| 6 | 24443 | |
| 4 | 6763 | 11.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1167970 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 228491 | |
| O | 153021 | |
| N | 126534 | |
| W | 111312 | |
| D | 73836 | 6.3% |
| L | 73836 | 6.3% |
| U | 46915 | 4.0% |
| Y | 44101 | 3.8% |
| E | 33393 | 2.9% |
| V | 31541 | 2.7% |
| Other values (12) | 244990 |
OP_CARRIER_AIRLINE_ID
Real number (ℝ)
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19983.213 |
| Minimum | 19393 |
|---|---|
| Maximum | 20452 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 19393 |
|---|---|
| 5-th percentile | 19393 |
| Q1 | 19790 |
| median | 19977 |
| Q3 | 20368 |
| 95-th percentile | 20436 |
| Maximum | 20452 |
| Range | 1059 |
| Interquartile range (IQR) | 578 |
Descriptive statistics
| Standard deviation | 377.72464 |
|---|---|
| Coefficient of variation (CV) | 0.018902097 |
| Kurtosis | -1.3049711 |
| Mean | 19983.213 |
| Median Absolute Deviation (MAD) | 386 |
| Skewness | -0.26626807 |
| Sum | 1.1669897 × 1010 |
| Variance | 142675.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 19393 | 111312 | |
| 19805 | 77017 | |
| 19790 | 73836 | |
| 20304 | 64926 | |
| 19977 | 46915 | |
| 20452 | 25755 | 4.4% |
| 20398 | 25699 | 4.4% |
| 20409 | 24443 | 4.2% |
| 20397 | 23169 | 4.0% |
| 19930 | 20744 | 3.6% |
| Other values (7) | 90169 |
| Value | Count | Frequency (%) |
| 19393 | 111312 | |
| 19690 | 6798 | 1.2% |
| 19790 | 73836 | |
| 19805 | 77017 | |
| 19930 | 20744 | 3.6% |
| 19977 | 46915 | |
| 20304 | 64926 | |
| 20363 | 20198 | 3.5% |
| 20366 | 13195 | 2.3% |
| 20368 | 6763 | 1.2% |
| Value | Count | Frequency (%) |
| 20452 | 25755 | |
| 20436 | 9647 | 1.7% |
| 20416 | 15222 | |
| 20409 | 24443 | |
| 20398 | 25699 | |
| 20397 | 23169 | |
| 20378 | 18346 | |
| 20368 | 6763 | 1.2% |
| 20366 | 13195 | |
| 20363 | 20198 |
OP_CARRIER
Categorical
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| WN | |
|---|---|
| AA | |
| DL | |
| OO | |
| UA | |
| Other values (12) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1167970 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 111312 | |
| AA | 77017 | |
| DL | 73836 | |
| OO | 64926 | |
| UA | 46915 | |
| YX | 25755 | 4.4% |
| MQ | 25699 | 4.4% |
| B6 | 24443 | 4.2% |
| OH | 23169 | 4.0% |
| AS | 20744 | 3.6% |
| Other values (7) | 90169 |
Length
| Value | Count | Frequency (%) |
| wn | 111312 | |
| aa | 77017 | |
| dl | 73836 | |
| oo | 64926 | |
| ua | 46915 | |
| yx | 25755 | 4.4% |
| mq | 25699 | 4.4% |
| b6 | 24443 | 4.2% |
| oh | 23169 | 4.0% |
| as | 20744 | 3.6% |
| Other values (7) | 90169 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 228491 | |
| O | 153021 | |
| N | 126534 | |
| W | 111312 | |
| D | 73836 | 6.3% |
| L | 73836 | 6.3% |
| U | 46915 | 4.0% |
| Y | 44101 | 3.8% |
| E | 33393 | 2.9% |
| V | 31541 | 2.7% |
| Other values (12) | 244990 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1106919 | |
| Decimal Number | 61051 | 5.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 228491 | |
| O | 153021 | |
| N | 126534 | |
| W | 111312 | |
| D | 73836 | 6.7% |
| L | 73836 | 6.7% |
| U | 46915 | 4.2% |
| Y | 44101 | 4.0% |
| E | 33393 | 3.0% |
| V | 31541 | 2.8% |
| Other values (9) | 183939 |
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 29845 | |
| 6 | 24443 | |
| 4 | 6763 | 11.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1106919 | |
| Common | 61051 | 5.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 228491 | |
| O | 153021 | |
| N | 126534 | |
| W | 111312 | |
| D | 73836 | 6.7% |
| L | 73836 | 6.7% |
| U | 46915 | 4.2% |
| Y | 44101 | 4.0% |
| E | 33393 | 3.0% |
| V | 31541 | 2.8% |
| Other values (9) | 183939 |
Common
| Value | Count | Frequency (%) |
| 9 | 29845 | |
| 6 | 24443 | |
| 4 | 6763 | 11.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1167970 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 228491 | |
| O | 153021 | |
| N | 126534 | |
| W | 111312 | |
| D | 73836 | 6.3% |
| L | 73836 | 6.3% |
| U | 46915 | 4.0% |
| Y | 44101 | 3.8% |
| E | 33393 | 2.9% |
| V | 31541 | 2.7% |
| Other values (12) | 244990 |
TAIL_NUM
Categorical
| Distinct | 5446 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 2543 |
| Missing (%) | 0.4% |
| Memory size | 4.5 MiB |
| N488HA | 361 |
|---|---|
| N481HA | 348 |
| N483HA | 346 |
| N489HA | 344 |
| N493HA | 328 |
| Other values (5441) |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.986033 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3480531 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 28 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | N8688C |
|---|---|
| 2nd row | N348PQ |
| 3rd row | N8896A |
| 4th row | N8886A |
| 5th row | N8974C |
Common Values
| Value | Count | Frequency (%) |
| N488HA | 361 | 0.1% |
| N481HA | 348 | 0.1% |
| N483HA | 346 | 0.1% |
| N489HA | 344 | 0.1% |
| N493HA | 328 | 0.1% |
| N485HA | 315 | 0.1% |
| N492HA | 305 | 0.1% |
| N486HA | 290 | < 0.1% |
| N480HA | 281 | < 0.1% |
| N479HA | 280 | < 0.1% |
| Other values (5436) | 578244 | |
| (Missing) | 2543 | 0.4% |
Length
| Value | Count | Frequency (%) |
| n488ha | 361 | 0.1% |
| n481ha | 348 | 0.1% |
| n483ha | 346 | 0.1% |
| n489ha | 344 | 0.1% |
| n493ha | 328 | 0.1% |
| n485ha | 315 | 0.1% |
| n492ha | 305 | 0.1% |
| n486ha | 290 | < 0.1% |
| n480ha | 281 | < 0.1% |
| n479ha | 280 | < 0.1% |
| Other values (5436) | 578244 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 757622 | |
| 8 | 229511 | 6.6% |
| 9 | 214602 | 6.2% |
| 7 | 203303 | 5.8% |
| 2 | 199511 | 5.7% |
| 3 | 195711 | 5.6% |
| 5 | 188043 | 5.4% |
| 1 | 182038 | 5.2% |
| 6 | 181942 | 5.2% |
| 4 | 175544 | 5.0% |
| Other values (24) | 952704 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1901962 | |
| Uppercase Letter | 1578569 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 757622 | |
| A | 141091 | 8.9% |
| W | 110015 | 7.0% |
| S | 93262 | 5.9% |
| D | 46495 | 2.9% |
| U | 44283 | 2.8% |
| J | 41335 | 2.6% |
| B | 40318 | 2.6% |
| E | 36500 | 2.3% |
| K | 34466 | 2.2% |
| Other values (14) | 233182 | 14.8% |
Decimal Number
| Value | Count | Frequency (%) |
| 8 | 229511 | |
| 9 | 214602 | |
| 7 | 203303 | |
| 2 | 199511 | |
| 3 | 195711 | |
| 5 | 188043 | |
| 1 | 182038 | |
| 6 | 181942 | |
| 4 | 175544 | |
| 0 | 131757 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1901962 | |
| Latin | 1578569 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 757622 | |
| A | 141091 | 8.9% |
| W | 110015 | 7.0% |
| S | 93262 | 5.9% |
| D | 46495 | 2.9% |
| U | 44283 | 2.8% |
| J | 41335 | 2.6% |
| B | 40318 | 2.6% |
| E | 36500 | 2.3% |
| K | 34466 | 2.2% |
| Other values (14) | 233182 | 14.8% |
Common
| Value | Count | Frequency (%) |
| 8 | 229511 | |
| 9 | 214602 | |
| 7 | 203303 | |
| 2 | 199511 | |
| 3 | 195711 | |
| 5 | 188043 | |
| 1 | 182038 | |
| 6 | 181942 | |
| 4 | 175544 | |
| 0 | 131757 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3480531 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 757622 | |
| 8 | 229511 | 6.6% |
| 9 | 214602 | 6.2% |
| 7 | 203303 | 5.8% |
| 2 | 199511 | 5.7% |
| 3 | 195711 | 5.6% |
| 5 | 188043 | 5.4% |
| 1 | 182038 | 5.2% |
| 6 | 181942 | 5.2% |
| 4 | 175544 | 5.0% |
| Other values (24) | 952704 |
OP_CARRIER_FL_NUM
Real number (ℝ)
| Distinct | 6839 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2537.8693 |
| Minimum | 1 |
|---|---|
| Maximum | 7439 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 232 |
| Q1 | 979 |
| median | 2114 |
| Q3 | 3902 |
| 95-th percentile | 5831 |
| Maximum | 7439 |
| Range | 7438 |
| Interquartile range (IQR) | 2923 |
Descriptive statistics
| Standard deviation | 1821.7361 |
|---|---|
| Coefficient of variation (CV) | 0.7178211 |
| Kurtosis | -0.82533758 |
| Mean | 2537.8693 |
| Median Absolute Deviation (MAD) | 1386 |
| Skewness | 0.54136521 |
| Sum | 1.4820776 × 109 |
| Variance | 3318722.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 403 | 310 | 0.1% |
| 761 | 291 | < 0.1% |
| 465 | 287 | < 0.1% |
| 466 | 285 | < 0.1% |
| 546 | 283 | < 0.1% |
| 1106 | 282 | < 0.1% |
| 425 | 281 | < 0.1% |
| 794 | 278 | < 0.1% |
| 347 | 277 | < 0.1% |
| 55 | 276 | < 0.1% |
| Other values (6829) | 581135 |
| Value | Count | Frequency (%) |
| 1 | 136 | |
| 2 | 122 | |
| 3 | 159 | |
| 4 | 180 | |
| 5 | 105 | |
| 6 | 81 | < 0.1% |
| 7 | 169 | |
| 8 | 206 | |
| 9 | 162 | |
| 10 | 122 |
| Value | Count | Frequency (%) |
| 7439 | 54 | |
| 7438 | 54 | |
| 7437 | 27 | |
| 7436 | 31 | |
| 7435 | 7 | < 0.1% |
| 7434 | 41 | |
| 7433 | 31 | |
| 7432 | 62 | |
| 7431 | 27 | |
| 7430 | 31 |
ORIGIN_AIRPORT_ID
Real number (ℝ)
| Distinct | 346 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12659.702 |
| Minimum | 10135 |
|---|---|
| Maximum | 16218 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 13931 |
| 95-th percentile | 14893 |
| Maximum | 16218 |
| Range | 6083 |
| Interquartile range (IQR) | 2639 |
Descriptive statistics
| Standard deviation | 1519.4055 |
|---|---|
| Coefficient of variation (CV) | 0.12001906 |
| Kurtosis | -1.2976461 |
| Mean | 12659.702 |
| Median Absolute Deviation (MAD) | 1456 |
| Skewness | 0.088227442 |
| Sum | 7.3930761 × 109 |
| Variance | 2308593.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10397 | 31155 | 5.3% |
| 13930 | 26216 | 4.5% |
| 11298 | 23063 | 3.9% |
| 11057 | 19100 | 3.3% |
| 11292 | 18507 | 3.2% |
| 12892 | 17988 | 3.1% |
| 14107 | 14761 | 2.5% |
| 12266 | 14598 | 2.5% |
| 12953 | 13872 | 2.4% |
| 14771 | 13689 | 2.3% |
| Other values (336) | 391036 |
| Value | Count | Frequency (%) |
| 10135 | 339 | 0.1% |
| 10136 | 170 | < 0.1% |
| 10140 | 1731 | |
| 10141 | 62 | < 0.1% |
| 10146 | 84 | < 0.1% |
| 10155 | 116 | < 0.1% |
| 10157 | 129 | < 0.1% |
| 10158 | 298 | 0.1% |
| 10165 | 9 | < 0.1% |
| 10170 | 53 | < 0.1% |
| Value | Count | Frequency (%) |
| 16218 | 115 | < 0.1% |
| 15991 | 60 | < 0.1% |
| 15919 | 1048 | |
| 15841 | 62 | < 0.1% |
| 15624 | 494 | 0.1% |
| 15607 | 87 | < 0.1% |
| 15582 | 53 | < 0.1% |
| 15454 | 58 | < 0.1% |
| 15412 | 1350 | |
| 15411 | 116 | < 0.1% |
ORIGIN_AIRPORT_SEQ_ID
Real number (ℝ)
| Distinct | 346 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1265974.1 |
| Minimum | 1013505 |
|---|---|
| Maximum | 1621802 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1013505 |
|---|---|
| 5-th percentile | 1039707 |
| Q1 | 1129202 |
| median | 1288903 |
| Q3 | 1393102 |
| 95-th percentile | 1489302 |
| Maximum | 1621802 |
| Range | 608297 |
| Interquartile range (IQR) | 263900 |
Descriptive statistics
| Standard deviation | 151940.3 |
|---|---|
| Coefficient of variation (CV) | 0.12001849 |
| Kurtosis | -1.2976523 |
| Mean | 1265974.1 |
| Median Absolute Deviation (MAD) | 145601 |
| Skewness | 0.08822968 |
| Sum | 7.393099 × 1011 |
| Variance | 2.3085855 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1039707 | 31155 | 5.3% |
| 1393007 | 26216 | 4.5% |
| 1129806 | 23063 | 3.9% |
| 1105703 | 19100 | 3.3% |
| 1129202 | 18507 | 3.2% |
| 1289208 | 17988 | 3.1% |
| 1410702 | 14761 | 2.5% |
| 1226603 | 14598 | 2.5% |
| 1295304 | 13872 | 2.4% |
| 1477104 | 13689 | 2.3% |
| Other values (336) | 391036 |
| Value | Count | Frequency (%) |
| 1013505 | 339 | 0.1% |
| 1013603 | 170 | < 0.1% |
| 1014005 | 1731 | |
| 1014106 | 62 | < 0.1% |
| 1014602 | 84 | < 0.1% |
| 1015502 | 116 | < 0.1% |
| 1015706 | 129 | < 0.1% |
| 1015804 | 298 | 0.1% |
| 1016506 | 9 | < 0.1% |
| 1017004 | 53 | < 0.1% |
| Value | Count | Frequency (%) |
| 1621802 | 115 | < 0.1% |
| 1599102 | 60 | < 0.1% |
| 1591904 | 1048 | |
| 1584102 | 62 | < 0.1% |
| 1562404 | 494 | 0.1% |
| 1560702 | 87 | < 0.1% |
| 1558203 | 53 | < 0.1% |
| 1545405 | 58 | < 0.1% |
| 1541205 | 1350 | |
| 1541106 | 116 | < 0.1% |
ORIGIN
Categorical
| Distinct | 346 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| ATL | 31155 |
|---|---|
| ORD | 26216 |
| DFW | 23063 |
| CLT | 19100 |
| DEN | 18507 |
| Other values (341) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1751955 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | GNV |
|---|---|
| 2nd row | MSP |
| 3rd row | DTW |
| 4th row | TLH |
| 5th row | ATL |
Common Values
| Value | Count | Frequency (%) |
| ATL | 31155 | 5.3% |
| ORD | 26216 | 4.5% |
| DFW | 23063 | 3.9% |
| CLT | 19100 | 3.3% |
| DEN | 18507 | 3.2% |
| LAX | 17988 | 3.1% |
| PHX | 14761 | 2.5% |
| IAH | 14598 | 2.5% |
| LGA | 13872 | 2.4% |
| SFO | 13689 | 2.3% |
| Other values (336) | 391036 |
Length
| Value | Count | Frequency (%) |
| atl | 31155 | 5.3% |
| ord | 26216 | 4.5% |
| dfw | 23063 | 3.9% |
| clt | 19100 | 3.3% |
| den | 18507 | 3.2% |
| lax | 17988 | 3.1% |
| phx | 14761 | 2.5% |
| iah | 14598 | 2.5% |
| lga | 13872 | 2.4% |
| sfo | 13689 | 2.3% |
| Other values (336) | 391036 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 197390 | 11.3% |
| L | 168284 | 9.6% |
| S | 143334 | 8.2% |
| D | 135780 | 7.8% |
| T | 100119 | 5.7% |
| O | 93364 | 5.3% |
| C | 90737 | 5.2% |
| M | 77481 | 4.4% |
| F | 73904 | 4.2% |
| P | 68946 | 3.9% |
| Other values (16) | 602616 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1751955 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 197390 | 11.3% |
| L | 168284 | 9.6% |
| S | 143334 | 8.2% |
| D | 135780 | 7.8% |
| T | 100119 | 5.7% |
| O | 93364 | 5.3% |
| C | 90737 | 5.2% |
| M | 77481 | 4.4% |
| F | 73904 | 4.2% |
| P | 68946 | 3.9% |
| Other values (16) | 602616 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1751955 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 197390 | 11.3% |
| L | 168284 | 9.6% |
| S | 143334 | 8.2% |
| D | 135780 | 7.8% |
| T | 100119 | 5.7% |
| O | 93364 | 5.3% |
| C | 90737 | 5.2% |
| M | 77481 | 4.4% |
| F | 73904 | 4.2% |
| P | 68946 | 3.9% |
| Other values (16) | 602616 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1751955 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 197390 | 11.3% |
| L | 168284 | 9.6% |
| S | 143334 | 8.2% |
| D | 135780 | 7.8% |
| T | 100119 | 5.7% |
| O | 93364 | 5.3% |
| C | 90737 | 5.2% |
| M | 77481 | 4.4% |
| F | 73904 | 4.2% |
| P | 68946 | 3.9% |
| Other values (16) | 602616 |
DEST_AIRPORT_ID
Real number (ℝ)
| Distinct | 346 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12659.47 |
| Minimum | 10135 |
|---|---|
| Maximum | 16218 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 13931 |
| 95-th percentile | 14893 |
| Maximum | 16218 |
| Range | 6083 |
| Interquartile range (IQR) | 2639 |
Descriptive statistics
| Standard deviation | 1519.3365 |
|---|---|
| Coefficient of variation (CV) | 0.1200158 |
| Kurtosis | -1.2977051 |
| Mean | 12659.47 |
| Median Absolute Deviation (MAD) | 1456 |
| Skewness | 0.088333171 |
| Sum | 7.3929406 × 109 |
| Variance | 2308383.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10397 | 31151 | 5.3% |
| 13930 | 26212 | 4.5% |
| 11298 | 23078 | 4.0% |
| 11057 | 19105 | 3.3% |
| 11292 | 18498 | 3.2% |
| 12892 | 17977 | 3.1% |
| 14107 | 14764 | 2.5% |
| 12266 | 14586 | 2.5% |
| 12953 | 13882 | 2.4% |
| 14771 | 13702 | 2.3% |
| Other values (336) | 391030 |
| Value | Count | Frequency (%) |
| 10135 | 340 | 0.1% |
| 10136 | 170 | < 0.1% |
| 10140 | 1732 | |
| 10141 | 62 | < 0.1% |
| 10146 | 84 | < 0.1% |
| 10155 | 116 | < 0.1% |
| 10157 | 130 | < 0.1% |
| 10158 | 298 | 0.1% |
| 10165 | 9 | < 0.1% |
| 10170 | 53 | < 0.1% |
| Value | Count | Frequency (%) |
| 16218 | 115 | < 0.1% |
| 15991 | 60 | < 0.1% |
| 15919 | 1049 | |
| 15841 | 62 | < 0.1% |
| 15624 | 494 | 0.1% |
| 15607 | 87 | < 0.1% |
| 15582 | 53 | < 0.1% |
| 15454 | 59 | < 0.1% |
| 15412 | 1350 | |
| 15411 | 116 | < 0.1% |
DEST_AIRPORT_SEQ_ID
Real number (ℝ)
| Distinct | 346 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1265950.9 |
| Minimum | 1013505 |
|---|---|
| Maximum | 1621802 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1013505 |
|---|---|
| 5-th percentile | 1039707 |
| Q1 | 1129202 |
| median | 1288903 |
| Q3 | 1393102 |
| 95-th percentile | 1489302 |
| Maximum | 1621802 |
| Range | 608297 |
| Interquartile range (IQR) | 263900 |
Descriptive statistics
| Standard deviation | 151933.4 |
|---|---|
| Coefficient of variation (CV) | 0.12001523 |
| Kurtosis | -1.2977113 |
| Mean | 1265950.9 |
| Median Absolute Deviation (MAD) | 145601 |
| Skewness | 0.088335412 |
| Sum | 7.3929635 × 1011 |
| Variance | 2.3083757 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1039707 | 31151 | 5.3% |
| 1393007 | 26212 | 4.5% |
| 1129806 | 23078 | 4.0% |
| 1105703 | 19105 | 3.3% |
| 1129202 | 18498 | 3.2% |
| 1289208 | 17977 | 3.1% |
| 1410702 | 14764 | 2.5% |
| 1226603 | 14586 | 2.5% |
| 1295304 | 13882 | 2.4% |
| 1477104 | 13702 | 2.3% |
| Other values (336) | 391030 |
| Value | Count | Frequency (%) |
| 1013505 | 340 | 0.1% |
| 1013603 | 170 | < 0.1% |
| 1014005 | 1732 | |
| 1014106 | 62 | < 0.1% |
| 1014602 | 84 | < 0.1% |
| 1015502 | 116 | < 0.1% |
| 1015706 | 130 | < 0.1% |
| 1015804 | 298 | 0.1% |
| 1016506 | 9 | < 0.1% |
| 1017004 | 53 | < 0.1% |
| Value | Count | Frequency (%) |
| 1621802 | 115 | < 0.1% |
| 1599102 | 60 | < 0.1% |
| 1591904 | 1049 | |
| 1584102 | 62 | < 0.1% |
| 1562404 | 494 | 0.1% |
| 1560702 | 87 | < 0.1% |
| 1558203 | 53 | < 0.1% |
| 1545405 | 59 | < 0.1% |
| 1541205 | 1350 | |
| 1541106 | 116 | < 0.1% |
DEST
Categorical
| Distinct | 346 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| ATL | 31151 |
|---|---|
| ORD | 26212 |
| DFW | 23078 |
| CLT | 19105 |
| DEN | 18498 |
| Other values (341) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1751955 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ATL |
|---|---|
| 2nd row | CVG |
| 3rd row | CVG |
| 4th row | ATL |
| 5th row | FSM |
Common Values
| Value | Count | Frequency (%) |
| ATL | 31151 | 5.3% |
| ORD | 26212 | 4.5% |
| DFW | 23078 | 4.0% |
| CLT | 19105 | 3.3% |
| DEN | 18498 | 3.2% |
| LAX | 17977 | 3.1% |
| PHX | 14764 | 2.5% |
| IAH | 14586 | 2.5% |
| LGA | 13882 | 2.4% |
| SFO | 13702 | 2.3% |
| Other values (336) | 391030 |
Length
| Value | Count | Frequency (%) |
| atl | 31151 | 5.3% |
| ord | 26212 | 4.5% |
| dfw | 23078 | 4.0% |
| clt | 19105 | 3.3% |
| den | 18498 | 3.2% |
| lax | 17977 | 3.1% |
| phx | 14764 | 2.5% |
| iah | 14586 | 2.5% |
| lga | 13882 | 2.4% |
| sfo | 13702 | 2.3% |
| Other values (336) | 391030 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 197382 | 11.3% |
| L | 168337 | 9.6% |
| S | 143375 | 8.2% |
| D | 135775 | 7.7% |
| T | 100066 | 5.7% |
| O | 93371 | 5.3% |
| C | 90766 | 5.2% |
| M | 77477 | 4.4% |
| F | 73910 | 4.2% |
| P | 68937 | 3.9% |
| Other values (16) | 602559 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1751955 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 197382 | 11.3% |
| L | 168337 | 9.6% |
| S | 143375 | 8.2% |
| D | 135775 | 7.7% |
| T | 100066 | 5.7% |
| O | 93371 | 5.3% |
| C | 90766 | 5.2% |
| M | 77477 | 4.4% |
| F | 73910 | 4.2% |
| P | 68937 | 3.9% |
| Other values (16) | 602559 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1751955 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 197382 | 11.3% |
| L | 168337 | 9.6% |
| S | 143375 | 8.2% |
| D | 135775 | 7.7% |
| T | 100066 | 5.7% |
| O | 93371 | 5.3% |
| C | 90766 | 5.2% |
| M | 77477 | 4.4% |
| F | 73910 | 4.2% |
| P | 68937 | 3.9% |
| Other values (16) | 602559 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1751955 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 197382 | 11.3% |
| L | 168337 | 9.6% |
| S | 143375 | 8.2% |
| D | 135775 | 7.7% |
| T | 100066 | 5.7% |
| O | 93371 | 5.3% |
| C | 90766 | 5.2% |
| M | 77477 | 4.4% |
| F | 73910 | 4.2% |
| P | 68937 | 3.9% |
| Other values (16) | 602559 |
DEP_TIME
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 1438 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 16352 |
| Missing (%) | 2.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1331.9578 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 603 |
| Q1 | 921 |
| median | 1328 |
| Q3 | 1738 |
| 95-th percentile | 2128 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 817 |
Descriptive statistics
| Standard deviation | 495.40402 |
|---|---|
| Coefficient of variation (CV) | 0.37193672 |
| Kurtosis | -0.98525653 |
| Mean | 1331.9578 |
| Median Absolute Deviation (MAD) | 409 |
| Skewness | 0.024633579 |
| Sum | 7.5606321 × 108 |
| Variance | 245425.14 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 555 | 1382 | 0.2% |
| 557 | 1237 | 0.2% |
| 556 | 1205 | 0.2% |
| 554 | 1191 | 0.2% |
| 558 | 1136 | 0.2% |
| 655 | 1123 | 0.2% |
| 559 | 1074 | 0.2% |
| 553 | 1067 | 0.2% |
| 654 | 1014 | 0.2% |
| 656 | 1010 | 0.2% |
| Other values (1428) | 556194 | |
| (Missing) | 16352 | 2.8% |
| Value | Count | Frequency (%) |
| 1 | 45 | |
| 2 | 49 | |
| 3 | 47 | |
| 4 | 43 | |
| 5 | 33 | |
| 6 | 33 | |
| 7 | 31 | |
| 8 | 33 | |
| 9 | 26 | |
| 10 | 40 |
| Value | Count | Frequency (%) |
| 2400 | 46 | |
| 2359 | 52 | |
| 2358 | 64 | |
| 2357 | 57 | |
| 2356 | 70 | |
| 2355 | 79 | |
| 2354 | 75 | |
| 2353 | 93 | |
| 2352 | 72 | |
| 2351 | 83 |
DEP_DEL15
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 16355 |
| Missing (%) | 2.8% |
| Memory size | 4.5 MiB |
| 0.0 | |
|---|---|
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1702890 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 468703 | |
| 1.0 | 98927 | 16.9% |
| (Missing) | 16355 | 2.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 468703 | |
| 1.0 | 98927 | 17.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1036333 | |
| . | 567630 | |
| 1 | 98927 | 5.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1135260 | |
| Other Punctuation | 567630 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1036333 | |
| 1 | 98927 | 8.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 567630 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1702890 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1036333 | |
| . | 567630 | |
| 1 | 98927 | 5.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1702890 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1036333 | |
| . | 567630 | |
| 1 | 98927 | 5.8% |
DEP_TIME_BLK
Categorical
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| 0600-0659 | |
|---|---|
| 0800-0859 | 39031 |
| 0700-0759 | 38450 |
| 1700-1759 | 37254 |
| 1200-1259 | 36918 |
| Other values (14) |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 5255865 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0600-0659 |
|---|---|
| 2nd row | 1400-1459 |
| 3rd row | 1200-1259 |
| 4th row | 1500-1559 |
| 5th row | 1900-1959 |
Common Values
| Value | Count | Frequency (%) |
| 0600-0659 | 41971 | 7.2% |
| 0800-0859 | 39031 | 6.7% |
| 0700-0759 | 38450 | 6.6% |
| 1700-1759 | 37254 | 6.4% |
| 1200-1259 | 36918 | 6.3% |
| 1100-1159 | 36774 | 6.3% |
| 1500-1559 | 35988 | 6.2% |
| 1400-1459 | 35925 | 6.2% |
| 1000-1059 | 35768 | 6.1% |
| 1600-1659 | 35250 | 6.0% |
| Other values (9) | 210656 |
Length
| Value | Count | Frequency (%) |
| 0600-0659 | 41971 | 7.2% |
| 0800-0859 | 39031 | 6.7% |
| 0700-0759 | 38450 | 6.6% |
| 1700-1759 | 37254 | 6.4% |
| 1200-1259 | 36918 | 6.3% |
| 1100-1159 | 36774 | 6.3% |
| 1500-1559 | 35988 | 6.2% |
| 1400-1459 | 35925 | 6.2% |
| 1000-1059 | 35768 | 6.1% |
| 1600-1659 | 35250 | 6.0% |
| Other values (9) | 210656 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1631046 | |
| 1 | 832679 | |
| 9 | 716399 | |
| 5 | 671838 | |
| - | 583985 | 11.1% |
| 2 | 220852 | 4.2% |
| 6 | 154442 | 2.9% |
| 7 | 151408 | 2.9% |
| 8 | 147402 | 2.8% |
| 3 | 73964 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4671880 | |
| Dash Punctuation | 583985 | 11.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1631046 | |
| 1 | 832679 | |
| 9 | 716399 | |
| 5 | 671838 | |
| 2 | 220852 | 4.7% |
| 6 | 154442 | 3.3% |
| 7 | 151408 | 3.2% |
| 8 | 147402 | 3.2% |
| 3 | 73964 | 1.6% |
| 4 | 71850 | 1.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 583985 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5255865 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1631046 | |
| 1 | 832679 | |
| 9 | 716399 | |
| 5 | 671838 | |
| - | 583985 | 11.1% |
| 2 | 220852 | 4.2% |
| 6 | 154442 | 2.9% |
| 7 | 151408 | 2.9% |
| 8 | 147402 | 2.8% |
| 3 | 73964 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5255865 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1631046 | |
| 1 | 832679 | |
| 9 | 716399 | |
| 5 | 671838 | |
| - | 583985 | 11.1% |
| 2 | 220852 | 4.2% |
| 6 | 154442 | 2.9% |
| 7 | 151408 | 2.9% |
| 8 | 147402 | 2.8% |
| 3 | 73964 | 1.4% |
ARR_TIME
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 17061 |
| Missing (%) | 2.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1484.3159 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 707 |
| Q1 | 1104 |
| median | 1517 |
| Q3 | 1919 |
| 95-th percentile | 2251 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 815 |
Descriptive statistics
| Standard deviation | 523.16285 |
|---|---|
| Coefficient of variation (CV) | 0.35246058 |
| Kurtosis | -0.37072307 |
| Mean | 1484.3159 |
| Median Absolute Deviation (MAD) | 408 |
| Skewness | -0.35448191 |
| Sum | 8.4149432 × 108 |
| Variance | 273699.37 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1645 | 674 | 0.1% |
| 2015 | 664 | 0.1% |
| 1015 | 661 | 0.1% |
| 1910 | 657 | 0.1% |
| 1008 | 656 | 0.1% |
| 2056 | 654 | 0.1% |
| 1400 | 651 | 0.1% |
| 2042 | 650 | 0.1% |
| 1633 | 650 | 0.1% |
| 1838 | 650 | 0.1% |
| Other values (1430) | 560357 | |
| (Missing) | 17061 | 2.9% |
| Value | Count | Frequency (%) |
| 1 | 301 | |
| 2 | 246 | |
| 3 | 240 | |
| 4 | 237 | |
| 5 | 249 | |
| 6 | 243 | |
| 7 | 222 | |
| 8 | 212 | |
| 9 | 234 | |
| 10 | 215 |
| Value | Count | Frequency (%) |
| 2400 | 252 | |
| 2359 | 278 | |
| 2358 | 320 | |
| 2357 | 304 | |
| 2356 | 301 | |
| 2355 | 263 | |
| 2354 | 327 | |
| 2353 | 344 | |
| 2352 | 362 | |
| 2351 | 332 |
ARR_DEL15
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 18022 |
| Missing (%) | 3.1% |
| Memory size | 4.5 MiB |
| 0.0 | |
|---|---|
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1697889 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 460741 | |
| 1.0 | 105222 | 18.0% |
| (Missing) | 18022 | 3.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 460741 | |
| 1.0 | 105222 | 18.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1026704 | |
| . | 565963 | |
| 1 | 105222 | 6.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1131926 | |
| Other Punctuation | 565963 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1026704 | |
| 1 | 105222 | 9.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 565963 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1697889 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1026704 | |
| . | 565963 | |
| 1 | 105222 | 6.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1697889 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1026704 | |
| . | 565963 | |
| 1 | 105222 | 6.2% |
CANCELLED
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| 0.0 | |
|---|---|
| 1.0 | 16726 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1751955 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 567259 | |
| 1.0 | 16726 | 2.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 567259 | |
| 1.0 | 16726 | 2.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1151244 | |
| . | 583985 | |
| 1 | 16726 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1167970 | |
| Other Punctuation | 583985 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1151244 | |
| 1 | 16726 | 1.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 583985 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1751955 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1151244 | |
| . | 583985 | |
| 1 | 16726 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1751955 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1151244 | |
| . | 583985 | |
| 1 | 16726 | 1.0% |
DIVERTED
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| 0.0 | |
|---|---|
| 1.0 | 1296 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1751955 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 582689 | |
| 1.0 | 1296 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 582689 | |
| 1.0 | 1296 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1166674 | |
| . | 583985 | |
| 1 | 1296 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1167970 | |
| Other Punctuation | 583985 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1166674 | |
| 1 | 1296 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 583985 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1751955 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1166674 | |
| . | 583985 | |
| 1 | 1296 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1751955 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1166674 | |
| . | 583985 | |
| 1 | 1296 | 0.1% |
DISTANCE
Real number (ℝ)
| Distinct | 1451 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 797.74277 |
| Minimum | 31 |
|---|---|
| Maximum | 4983 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 31 |
|---|---|
| 5-th percentile | 168 |
| Q1 | 363 |
| median | 640 |
| Q3 | 1037 |
| 95-th percentile | 2139 |
| Maximum | 4983 |
| Range | 4952 |
| Interquartile range (IQR) | 674 |
Descriptive statistics
| Standard deviation | 589.99926 |
|---|---|
| Coefficient of variation (CV) | 0.73958585 |
| Kurtosis | 2.6283324 |
| Mean | 797.74277 |
| Median Absolute Deviation (MAD) | 317 |
| Skewness | 1.4890764 |
| Sum | 4.6586981 × 108 |
| Variance | 348099.13 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 337 | 4167 | 0.7% |
| 296 | 3277 | 0.6% |
| 733 | 2875 | 0.5% |
| 214 | 2463 | 0.4% |
| 594 | 2411 | 0.4% |
| 404 | 2383 | 0.4% |
| 236 | 2330 | 0.4% |
| 447 | 2297 | 0.4% |
| 328 | 2211 | 0.4% |
| 335 | 2192 | 0.4% |
| Other values (1441) | 557379 |
| Value | Count | Frequency (%) |
| 31 | 62 | < 0.1% |
| 45 | 94 | < 0.1% |
| 66 | 62 | < 0.1% |
| 67 | 351 | |
| 68 | 124 | < 0.1% |
| 69 | 138 | < 0.1% |
| 73 | 390 | |
| 74 | 383 | |
| 75 | 532 | |
| 76 | 204 | < 0.1% |
| Value | Count | Frequency (%) |
| 4983 | 66 | |
| 4962 | 62 | |
| 4817 | 18 | < 0.1% |
| 4502 | 62 | |
| 4243 | 72 | |
| 4184 | 40 | < 0.1% |
| 3972 | 46 | < 0.1% |
| 3904 | 62 | |
| 3801 | 62 | |
| 3784 | 124 |
Unnamed: 21
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 583985 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 4.5 MiB |
| DAY_OF_MONTH | DAY_OF_WEEK | OP_CARRIER_AIRLINE_ID | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN_AIRPORT_SEQ_ID | DEST_AIRPORT_ID | DEST_AIRPORT_SEQ_ID | DEP_TIME | ARR_TIME | DISTANCE | OP_UNIQUE_CARRIER | OP_CARRIER | DEP_DEL15 | DEP_TIME_BLK | ARR_DEL15 | CANCELLED | DIVERTED | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DAY_OF_MONTH | 1.000 | -0.030 | -0.004 | -0.010 | -0.005 | -0.005 | -0.005 | -0.005 | -0.002 | 0.003 | -0.020 | 0.016 | 0.016 | 0.104 | 0.009 | 0.109 | 0.144 | 0.014 |
| DAY_OF_WEEK | -0.030 | 1.000 | 0.011 | 0.060 | 0.006 | 0.006 | 0.006 | 0.006 | 0.003 | 0.005 | 0.020 | 0.025 | 0.025 | 0.039 | 0.019 | 0.039 | 0.044 | 0.006 |
| OP_CARRIER_AIRLINE_ID | -0.004 | 0.011 | 1.000 | 0.339 | -0.032 | -0.032 | -0.032 | -0.032 | 0.008 | -0.017 | -0.098 | 1.000 | 1.000 | 0.063 | 0.058 | 0.084 | 0.075 | 0.025 |
| OP_CARRIER_FL_NUM | -0.010 | 0.060 | 0.339 | 1.000 | -0.053 | -0.053 | -0.059 | -0.059 | 0.009 | -0.002 | -0.334 | 0.469 | 0.469 | 0.037 | 0.040 | 0.055 | 0.064 | 0.012 |
| ORIGIN_AIRPORT_ID | -0.005 | 0.006 | -0.032 | -0.053 | 1.000 | 1.000 | 0.019 | 0.019 | -0.033 | -0.002 | 0.092 | 0.184 | 0.184 | 0.036 | 0.056 | 0.042 | 0.052 | 0.004 |
| ORIGIN_AIRPORT_SEQ_ID | -0.005 | 0.006 | -0.032 | -0.053 | 1.000 | 1.000 | 0.019 | 0.019 | -0.033 | -0.002 | 0.092 | 0.184 | 0.184 | 0.036 | 0.056 | 0.042 | 0.052 | 0.004 |
| DEST_AIRPORT_ID | -0.005 | 0.006 | -0.032 | -0.059 | 0.019 | 0.019 | 1.000 | 1.000 | 0.026 | 0.022 | 0.092 | 0.184 | 0.184 | 0.041 | 0.043 | 0.047 | 0.054 | 0.015 |
| DEST_AIRPORT_SEQ_ID | -0.005 | 0.006 | -0.032 | -0.059 | 0.019 | 0.019 | 1.000 | 1.000 | 0.026 | 0.022 | 0.092 | 0.184 | 0.184 | 0.041 | 0.043 | 0.047 | 0.054 | 0.015 |
| DEP_TIME | -0.002 | 0.003 | 0.008 | 0.009 | -0.033 | -0.033 | 0.026 | 0.026 | 1.000 | 0.781 | -0.039 | 0.051 | 0.051 | 0.214 | 0.769 | 0.162 | 0.009 | 0.009 |
| ARR_TIME | 0.003 | 0.005 | -0.017 | -0.002 | -0.002 | -0.002 | 0.022 | 0.022 | 0.781 | 1.000 | 0.055 | 0.054 | 0.054 | 0.243 | 0.558 | 0.218 | 1.000 | 0.023 |
| DISTANCE | -0.020 | 0.020 | -0.098 | -0.334 | 0.092 | 0.092 | 0.092 | 0.092 | -0.039 | 0.055 | 1.000 | 0.182 | 0.182 | 0.023 | 0.076 | 0.019 | 0.049 | 0.017 |
| OP_UNIQUE_CARRIER | 0.016 | 0.025 | 1.000 | 0.469 | 0.184 | 0.184 | 0.184 | 0.184 | 0.051 | 0.054 | 0.182 | 1.000 | 1.000 | 0.090 | 0.052 | 0.109 | 0.107 | 0.028 |
| OP_CARRIER | 0.016 | 0.025 | 1.000 | 0.469 | 0.184 | 0.184 | 0.184 | 0.184 | 0.051 | 0.054 | 0.182 | 1.000 | 1.000 | 0.090 | 0.052 | 0.109 | 0.107 | 0.028 |
| DEP_DEL15 | 0.104 | 0.039 | 0.063 | 0.037 | 0.036 | 0.036 | 0.041 | 0.041 | 0.214 | 0.243 | 0.023 | 0.090 | 0.090 | 1.000 | 0.146 | 0.719 | 0.022 | 0.021 |
| DEP_TIME_BLK | 0.009 | 0.019 | 0.058 | 0.040 | 0.056 | 0.056 | 0.043 | 0.043 | 0.769 | 0.558 | 0.076 | 0.052 | 0.052 | 0.146 | 1.000 | 0.102 | 0.022 | 0.008 |
| ARR_DEL15 | 0.109 | 0.039 | 0.084 | 0.055 | 0.042 | 0.042 | 0.047 | 0.047 | 0.162 | 0.218 | 0.019 | 0.109 | 0.109 | 0.719 | 0.102 | 1.000 | 1.000 | 1.000 |
| CANCELLED | 0.144 | 0.044 | 0.075 | 0.064 | 0.052 | 0.052 | 0.054 | 0.054 | 0.009 | 1.000 | 0.049 | 0.107 | 0.107 | 0.022 | 0.022 | 1.000 | 1.000 | 0.008 |
| DIVERTED | 0.014 | 0.006 | 0.025 | 0.012 | 0.004 | 0.004 | 0.015 | 0.015 | 0.009 | 0.023 | 0.017 | 0.028 | 0.028 | 0.021 | 0.008 | 1.000 | 0.008 | 1.000 |
| DAY_OF_MONTH | DAY_OF_WEEK | OP_UNIQUE_CARRIER | OP_CARRIER_AIRLINE_ID | OP_CARRIER | TAIL_NUM | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN_AIRPORT_SEQ_ID | ORIGIN | DEST_AIRPORT_ID | DEST_AIRPORT_SEQ_ID | DEST | DEP_TIME | DEP_DEL15 | DEP_TIME_BLK | ARR_TIME | ARR_DEL15 | CANCELLED | DIVERTED | DISTANCE | Unnamed: 21 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 2 | 9E | 20363 | 9E | N8688C | 3280 | 11953 | 1195302 | GNV | 10397 | 1039707 | ATL | 601.0 | 0.0 | 0600-0659 | 722.0 | 0.0 | 0.0 | 0.0 | 300.0 | NaN |
| 1 | 1 | 2 | 9E | 20363 | 9E | N348PQ | 3281 | 13487 | 1348702 | MSP | 11193 | 1119302 | CVG | 1359.0 | 0.0 | 1400-1459 | 1633.0 | 0.0 | 0.0 | 0.0 | 596.0 | NaN |
| 2 | 1 | 2 | 9E | 20363 | 9E | N8896A | 3282 | 11433 | 1143302 | DTW | 11193 | 1119302 | CVG | 1215.0 | 0.0 | 1200-1259 | 1329.0 | 0.0 | 0.0 | 0.0 | 229.0 | NaN |
| 3 | 1 | 2 | 9E | 20363 | 9E | N8886A | 3283 | 15249 | 1524906 | TLH | 10397 | 1039707 | ATL | 1521.0 | 0.0 | 1500-1559 | 1625.0 | 0.0 | 0.0 | 0.0 | 223.0 | NaN |
| 4 | 1 | 2 | 9E | 20363 | 9E | N8974C | 3284 | 10397 | 1039707 | ATL | 11778 | 1177801 | FSM | 1847.0 | 0.0 | 1900-1959 | 1940.0 | 0.0 | 0.0 | 0.0 | 579.0 | NaN |
| 5 | 1 | 2 | 9E | 20363 | 9E | N927EV | 3285 | 11267 | 1126702 | DAY | 13487 | 1348702 | MSP | 853.0 | 0.0 | 0900-0959 | 953.0 | 0.0 | 0.0 | 0.0 | 574.0 | NaN |
| 6 | 1 | 2 | 9E | 20363 | 9E | N915XJ | 3286 | 12448 | 1244807 | JAN | 10397 | 1039707 | ATL | 1553.0 | 0.0 | 1500-1559 | 1832.0 | 0.0 | 0.0 | 0.0 | 341.0 | NaN |
| 7 | 1 | 2 | 9E | 20363 | 9E | N295PQ | 3287 | 12953 | 1295304 | LGA | 11193 | 1119302 | CVG | 1551.0 | 0.0 | 1500-1559 | 1824.0 | 0.0 | 0.0 | 0.0 | 585.0 | NaN |
| 8 | 1 | 2 | 9E | 20363 | 9E | N337PQ | 3288 | 12451 | 1245102 | JAX | 12953 | 1295304 | LGA | 1037.0 | 0.0 | 1000-1059 | 1239.0 | 0.0 | 0.0 | 0.0 | 833.0 | NaN |
| 9 | 1 | 2 | 9E | 20363 | 9E | N311PQ | 3289 | 10397 | 1039707 | ATL | 10685 | 1068502 | BMI | 1245.0 | 0.0 | 1200-1259 | 1318.0 | 0.0 | 0.0 | 0.0 | 533.0 | NaN |
| DAY_OF_MONTH | DAY_OF_WEEK | OP_UNIQUE_CARRIER | OP_CARRIER_AIRLINE_ID | OP_CARRIER | TAIL_NUM | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN_AIRPORT_SEQ_ID | ORIGIN | DEST_AIRPORT_ID | DEST_AIRPORT_SEQ_ID | DEST | DEP_TIME | DEP_DEL15 | DEP_TIME_BLK | ARR_TIME | ARR_DEL15 | CANCELLED | DIVERTED | DISTANCE | Unnamed: 21 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 583975 | 31 | 4 | UA | 19977 | UA | N813UA | 205 | 14771 | 1477104 | SFO | 14057 | 1405702 | PDX | 604.0 | 0.0 | 0600-0659 | 802.0 | 0.0 | 0.0 | 0.0 | 550.0 | NaN |
| 583976 | 31 | 4 | UA | 19977 | UA | N75861 | 204 | 13930 | 1393007 | ORD | 12892 | 1289208 | LAX | 813.0 | 1.0 | 0700-0759 | 1028.0 | 0.0 | 0.0 | 0.0 | 1744.0 | NaN |
| 583977 | 31 | 4 | UA | 19977 | UA | N39728 | 203 | 10693 | 1069302 | BNA | 12266 | 1226603 | IAH | 1105.0 | 0.0 | 1100-1159 | 1335.0 | 1.0 | 0.0 | 0.0 | 657.0 | NaN |
| 583978 | 31 | 4 | UA | 19977 | UA | N779UA | 202 | 13930 | 1393007 | ORD | 13830 | 1383002 | OGG | 1027.0 | 1.0 | 1000-1059 | 1457.0 | 0.0 | 0.0 | 0.0 | 4184.0 | NaN |
| 583979 | 31 | 4 | UA | 19977 | UA | N769UA | 201 | 12173 | 1217305 | HNL | 12016 | 1201602 | GUM | 1502.0 | 0.0 | 1500-1559 | 1849.0 | 0.0 | 0.0 | 0.0 | 3801.0 | NaN |
| 583980 | 31 | 4 | UA | 19977 | UA | N776UA | 200 | 12016 | 1201602 | GUM | 12173 | 1217305 | HNL | 749.0 | 0.0 | 0700-0759 | 1832.0 | 0.0 | 0.0 | 0.0 | 3801.0 | NaN |
| 583981 | 31 | 4 | UA | 19977 | UA | N36280 | 174 | 12016 | 1201602 | GUM | 14955 | 1495503 | SPN | 717.0 | 0.0 | 0700-0759 | 759.0 | 0.0 | 0.0 | 0.0 | 129.0 | NaN |
| 583982 | 31 | 4 | UA | 19977 | UA | N36280 | 117 | 14955 | 1495503 | SPN | 12016 | 1201602 | GUM | 857.0 | 0.0 | 0900-0959 | 933.0 | 0.0 | 0.0 | 0.0 | 129.0 | NaN |
| 583983 | 31 | 4 | UA | 19977 | UA | N39726 | 105 | 14955 | 1495503 | SPN | 12016 | 1201602 | GUM | 1820.0 | 0.0 | 1800-1859 | 1854.0 | 0.0 | 0.0 | 0.0 | 129.0 | NaN |
| 583984 | 31 | 4 | UA | 19977 | UA | N39726 | 104 | 12016 | 1201602 | GUM | 14955 | 1495503 | SPN | 1636.0 | 0.0 | 1600-1659 | 1719.0 | 0.0 | 0.0 | 0.0 | 129.0 | NaN |